oracle 求sql语句 按照日期范围分组查询。请务必写出测试过的代码,有难...答:to_date('2013-05-23','yyyy-mm-dd'),'b',900);with t as(select rownum rn,to_char(trunc(to_date('2012-01-01','yyyy-mm-dd'),'d')+rownum*7+1,'yyyy-mm-dd') time1,to_char(trunc(to_date('2012-01-01','yyyy-mm-dd'),'d')+(rownum+1)*7,'yyyy-mm-dd') time...